{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Resumen","inventario"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Resumen","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["INFORME situación actual a fecha",null,{"$f":"A5","v":"2024-11-17"},null,null,"STOCK MINIMO ",50]
[null,null,null,null,null,"STOCK MAXIMO",15000]
[]
["Ultima fecha de registro","PRODUCTOS","Entradas","Salidas","PMP","EXISTENCIAS ACTUALES- CANTIDAD","Punto Reorden","PMP con función COCIENTE"]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Camiseta básica blanca",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":32000},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-17880},{"$f":"SUMIFS(inventario!I3:I26,inventario!C3:C26,B5,inventario!D3:D26,\"Entrada\")/SUMIFS(inventario!G3:G26,inventario!C3:C26,B5,inventario!D3:D26,\"Entrada\")","v":20.643750000000001},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B5)","v":14120},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":""},{"$f":"QUOTIENT(SUMIFS(inventario!I3:I26,inventario!C3:C26,B5,inventario!D3:D26,\"Entrada\"),SUMIFS(inventario!G3:G26,inventario!C3:C26,B5,inventario!D3:D26,\"Entrada\"))","v":20}]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Jersey de lana gris",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":19200},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-19200},{"$f":"SUMIFS(inventario!I4:I27,inventario!C4:C27,B6,inventario!D4:D27,\"Entrada\")/SUMIFS(inventario!G4:G27,inventario!C4:C27,B6,inventario!D4:D27,\"Entrada\")","v":16.545833333333334},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B6)","v":0},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":"realizar un nuevo pedido"},{"$f":"QUOTIENT(SUMIFS(inventario!I4:I27,inventario!C4:C27,B6,inventario!D4:D27,\"Entrada\"),SUMIFS(inventario!G4:G27,inventario!C4:C27,B6,inventario!D4:D27,\"Entrada\"))","v":16}]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Camiseta básica negra",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":6010},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-5111},{"$f":"SUMIFS(inventario!I5:I28,inventario!C5:C28,B7,inventario!D5:D28,\"Entrada\")/SUMIFS(inventario!G5:G28,inventario!C5:C28,B7,inventario!D5:D28,\"Entrada\")","v":15.989999999999998},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B7)","v":899},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":""},{"$f":"QUOTIENT(SUMIFS(inventario!I5:I28,inventario!C5:C28,B7,inventario!D5:D28,\"Entrada\"),SUMIFS(inventario!G5:G28,inventario!C5:C28,B7,inventario!D5:D28,\"Entrada\"))","v":15}]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Cazadora de cuero marrón",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":3630},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-3085},{"$f":"SUMIFS(inventario!I6:I29,inventario!C6:C29,B8,inventario!D6:D29,\"Entrada\")/SUMIFS(inventario!G6:G29,inventario!C6:C29,B8,inventario!D6:D29,\"Entrada\")","v":28.93},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B8)","v":545},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":""},{"$f":"QUOTIENT(SUMIFS(inventario!I6:I29,inventario!C6:C29,B8,inventario!D6:D29,\"Entrada\"),SUMIFS(inventario!G6:G29,inventario!C6:C29,B8,inventario!D6:D29,\"Entrada\"))","v":28}]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Pantalón clásico negro",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":5976},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-5976},{"$f":"SUMIFS(inventario!I7:I30,inventario!C7:C30,B9,inventario!D7:D30,\"Entrada\")/SUMIFS(inventario!G7:G30,inventario!C7:C30,B9,inventario!D7:D30,\"Entrada\")","v":22.300000000000004},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B9)","v":0},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":"realizar un nuevo pedido"},{"$f":"QUOTIENT(SUMIFS(inventario!I7:I30,inventario!C7:C30,B9,inventario!D7:D30,\"Entrada\"),SUMIFS(inventario!G7:G30,inventario!C7:C30,B9,inventario!D7:D30,\"Entrada\"))","v":22}]
[{"$f":"LOOKUP(2,1/(inventario!A:A<>\"\"),inventario!A:A)","v":"2024-11-17"},"Falda plisada estampada",{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\">0\")","v":23484},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,Tabla1[[#This Row],[PRODUCTOS]],inventario!$G$3:$G$26,\"<0\")","v":-16054},{"$f":"SUMIFS(inventario!I8:I31,inventario!C8:C31,B10,inventario!D8:D31,\"Entrada\")/SUMIFS(inventario!G8:G31,inventario!C8:C31,B10,inventario!D8:D31,\"Entrada\")","v":22.98126852324987},{"$f":"SUMIFS(inventario!$G$3:$G$26,inventario!$C$3:$C$26,B10)","v":7430},{"$f":"IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]<$G$1,\"realizar un nuevo pedido\",IF(Tabla1[[#This Row],[EXISTENCIAS ACTUALES- CANTIDAD]]>=$G$2,\"superamos el stock máximo\",\"\"))","v":""},{"$f":"QUOTIENT(SUMIFS(inventario!I8:I31,inventario!C8:C31,B10,inventario!D8:D31,\"Entrada\"),SUMIFS(inventario!G8:G31,inventario!C8:C31,B10,inventario!D8:D31,\"Entrada\"))","v":22}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"ñoljlkijkljkljklhkjldwjklaqsjkljkl"]

{"sheet":"inventario","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Control Entradas y Salidas"]
["Fecha Operación","Código del producto","Producto","Operación","Proveedor/","Num. Factura","cantidad","precio ","importe"]
["2024-05-01","Cababla01","Camiseta básica blanca","Entrada","cliente","A2024-1",10000,18.46,{"$f":"IF(inventario!$H3<>\"\",inventario!$G3*inventario!$H3,\"\")","v":184600}]
["2024-05-02","Cababla01","Camiseta básica blanca","Salida","ZACIL STRAPLINE  S.L. ","S2024-1",-8400,null,{"$f":"IF(inventario!$H4<>\"\",inventario!$G4*inventario!$H4,\"\")","v":""}]
["2024-05-02","jlan01","Jersey de lana gris","Entrada","Moda Urbana S.L.","A2024-2",11200,17.649999999999999,{"$f":"IF(inventario!$H5<>\"\",inventario!$G5*inventario!$H5,\"\")","v":197679.99999999997}]
["2024-05-04","jlan01","Jersey de lana gris","Salida","ZACIL STRAPLINE  S.L. ","S2024-2",-8500,null,{"$f":"IF(inventario!$H6<>\"\",inventario!$G6*inventario!$H6,\"\")","v":""}]
["2024-05-05","Cababla01","Camiseta básica blanca","Entrada","Moda Textil S.A.","A2024-3",10000,20,{"$f":"IF(inventario!$H7<>\"\",inventario!$G7*inventario!$H7,\"\")","v":200000}]
["2024-05-08","jlan01","Jersey de lana gris","Entrada","Moda Urbana S.L.","A2024-4",8000,15,{"$f":"IF(inventario!$H8<>\"\",inventario!$G8*inventario!$H8,\"\")","v":120000}]
["2024-06-20","Cababla01","Camiseta básica blanca","Salida","MARA STRAPLINE S.A.","S2024-3",-1480,null,{"$f":"IF(inventario!$H9<>\"\",inventario!$G9*inventario!$H9,\"\")","v":""}]
["2024-06-20","jlan01","Jersey de lana gris","Salida","MARA STRAPLINE S.A.","S2024-3",-10200,null,{"$f":"IF(inventario!$H10<>\"\",inventario!$G10*inventario!$H10,\"\")","v":""}]
["2024-06-28","falplies01","Falda plisada estampada","Entrada","Moda Elegante S.A.","A2024-5",10941,23.96,{"$f":"IF(inventario!$H11<>\"\",inventario!$G11*inventario!$H11,\"\")","v":262146.36}]
["2024-06-29","Cabane01","Camiseta básica negra","Entrada","Moda Textil S.A.","A2024-6",6010,15.99,{"$f":"IF(inventario!$H12<>\"\",inventario!$G12*inventario!$H12,\"\")","v":96099.9}]
["2024-06-30","Cababla01","Camiseta básica blanca","Salida","MARA STRAPLINE S.A.","S2024-4",-8000,null,{"$f":"IF(inventario!$H13<>\"\",inventario!$G13*inventario!$H13,\"\")","v":""}]
["2024-06-30","paclane01","Pantalón clásico negro","Entrada","Moda Elegante S.A.","A2024-7",5976,22.3,{"$f":"IF(inventario!$H14<>\"\",inventario!$G14*inventario!$H14,\"\")","v":133264.80000000002}]
["2024-07-01","Cabane01","Camiseta básica negra","Salida","ZACIL STRAPLINE  S.L. ","S2024-5",-5111,null,{"$f":"IF(inventario!$H15<>\"\",inventario!$G15*inventario!$H15,\"\")","v":""}]
["2024-07-14","Cababla01","Jersey de lana gris","Salida","MARA STRAPLINE S.A.","S2024-6",-500,null,{"$f":"IF(inventario!$H16<>\"\",inventario!$G16*inventario!$H16,\"\")","v":""}]
["2024-07-14","Cababla01","Camiseta básica blanca","Entrada","Moda Textil S.A.","A2024-8",12000,23,{"$f":"IF(inventario!$H17<>\"\",inventario!$G17*inventario!$H17,\"\")","v":276000}]
["2024-07-23","cacma01","Cazadora de cuero marrón","Entrada","Moda Elegante S.A.","A2024-9",3630,28.93,{"$f":"IF(inventario!$H18<>\"\",inventario!$G18*inventario!$H18,\"\")","v":105015.9}]
["2024-07-25","cacma01","Cazadora de cuero marrón","Salida","ZACIL STRAPLINE  S.L. ","S2024-7",-3085,null,{"$f":"IF(inventario!$H19<>\"\",inventario!$G19*inventario!$H19,\"\")","v":""}]
["2024-07-25","falplies01","Falda plisada estampada","Entrada","Moda Elegante S.A.","A2024-10",7934,25.6,{"$f":"IF(inventario!$H20<>\"\",inventario!$G20*inventario!$H20,\"\")","v":203110.40000000002}]
["2024-08-01","paclane01","Pantalón clásico negro","Salida","MARA STRAPLINE S.A.","S2024-8",-5080,null,{"$f":"IF(inventario!$H21<>\"\",inventario!$G21*inventario!$H21,\"\")","v":""}]
["2024-08-01","falplies01","Falda plisada estampada","Salida","MARA STRAPLINE S.A.","S2024-8",-6744,null,{"$f":"IF(inventario!$H22<>\"\",inventario!$G22*inventario!$H22,\"\")","v":""}]
["2024-08-05","paclane01","Pantalón clásico negro","Salida","ZACIL STRAPLINE  S.L. ","S2024-9",-896,null,{"$f":"IF(inventario!$H23<>\"\",inventario!$G23*inventario!$H23,\"\")","v":""}]
["2024-09-18","falplies01","Falda plisada estampada","Salida","MARA STRAPLINE S.A.","S2024-10",-9300,null,{"$f":"IF(inventario!$H24<>\"\",inventario!$G24*inventario!$H24,\"\")","v":""}]
["2024-11-15","falplies01","Falda plisada estampada","Entrada","Moda Elegante S.A.","A2024-11",4609,16.149999999999999,{"$f":"IF(inventario!$H25<>\"\",inventario!$G25*inventario!$H25,\"\")","v":74435.349999999991}]
["2024-11-17","falplies01","Falda plisada estampada","Salida","Ajuste: camisetas manchadas","Al2024-01",-10,null,{"$f":"IF(inventario!$H26<>\"\",inventario!$G26*inventario!$H26,\"\")","v":""}]